USE [nexdox_BBOS_DEV]
GO

/****** Object:  View [dbo].[UserAuthorisedView]    Script Date: 24/03/2015 15:25:31 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


ALTER view [dbo].[UserAuthorisedView]
as
select c.JobID, a.UserName,a.FirstName,a.LastName from 
AspNetUsers a inner join AuthoriseHistory b on a.Id = b.UserID
inner join Job c on b.JobID = c.JobID
GO


